CREATE TABLE [dbo].[Zip3]
(
[ZIP_3] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZIP_3] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_CITY] DEFAULT (''),
[STATE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_STATE] DEFAULT (''),
[ZIP_TYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZIP_TYPE] DEFAULT (''),
[ZONE_1] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZONE_1] DEFAULT (''),
[ZONE_2] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZONE_2] DEFAULT (''),
[ZONE_3] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZONE_3] DEFAULT (''),
[ZONE_4] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZONE_4] DEFAULT (''),
[ZONE_5] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_ZONE_5] DEFAULT (''),
[CHAPTER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Zip3_CHAPTER] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Zip3] ADD CONSTRAINT [PK_Zip3] PRIMARY KEY CLUSTERED ([ZIP_3]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Zip3] TO [IMIS]
GRANT SELECT ON  [dbo].[Zip3] TO [IMIS]
GRANT INSERT ON  [dbo].[Zip3] TO [IMIS]
GRANT DELETE ON  [dbo].[Zip3] TO [IMIS]
GRANT UPDATE ON  [dbo].[Zip3] TO [IMIS]
GO